Stacked Bar Chart 14

Avg Units Available, Avg Applicants vs Avg Mths Waiting

1. Create New Sheet, 2. Rename, 3. Double click on the Title, Dialog box opens - 4. Highlight <Sheet Name> 5. Edit/Format title Size 11, Bold




Create the Stacked Bar chart

Drag and drop Program in column shelf,  Units available in Row shelf,  Click the Descending order icon, Drag and drop Applicants on the y-axis( when the green dual ruler icon is visible, drop applicants on the axis),  Bring the Measure names pill to color,  Change the measures aggregate to Average.

See gif




Dual Axis

Drag and drop Months Waiting to right axis, Change aggregate to Average, Change the Marks (Measures Values to Bar and Avg(Months Waiting) to line ), Bring Months Waiting to label, Change aggregate to Average, Edit both axis to remove title.

See gif




Color and formatting

Edit colors, double click on each field, add the color code (Avg. Applicants -  #5c6068 , Avg Units Available  -  #006c84,    Avg Months Waiting - #8493a7) ,    Hide Program header, Right click sheet space to edit, Right click on axis to select Format to Edit in the options on the left pane.                 

See gif




Tooltip

Select ALL on the Marks shelf, Drag and Drop the Avg Months Waiting indicators to Detail, Click Tooltip, Copy and paste (fields below), Preview and Click OK

<Program>

<Measure Names>: <Measure Values>

Avg. Months Waiting: <AVG(Months Waiting)><AGG(cc.YoY Mths Waiting UP)><AGG(cc.YoY Mths Waiting DOWN)>

see gif






Tableau - Bar Chart & Stacked Chart:

https://www.youtube.com/watch?v=gUSevSBvLwU&t=71s